QUERY_ALL = "SELECT " \
            "inlayOrder.id," \
            "inlayOrder.inlay_sn," \
            "inlayOrder.inlay_status," \
            "case inlayOrder.inlay_status" \
            " WHEN 0 THEN '待库房审核'" \
            " WHEN 1 THEN '待供应链审核'" \
            " WHEN 2 THEN '待供应链回库'" \
            " end as inlayStatusName," \
            "inlayOrder.inlay_level," \
            "case inlayOrder.inlay_level" \
            " WHEN 0 THEN 'A'" \
            " WHEN 1 THEN 'B'" \
            " WHEN 2 THEN 'C'" \
            " WHEN 3 THEN 'D'" \
            " end as inlayLevelName," \
            "inlayOrder.inlay_category," \
            "case inlayOrder.inlay_category" \
            " WHEN 0 THEN '维修'" \
            " WHEN 1 THEN '客订镶嵌'" \
            " end as inlayCategoryName," \
            " (SELECT SUM(inlay_num) FROM bojem_microservice_order.inlay_order_goods WHERE inlay_order_id = inlayOrder.id AND if_del =1 ) as inlayNum, " \
            "0 as warehouseInventory" \
            " FROM " \
            " bojem_microservice_order.inlay_order inlayOrder" \
            " WHERE inlayOrder.if_del =1 " \
            " AND inlayOrder.inlay_status <=2"
